Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	5695
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	622.9 KiB
Average record size in memory	112.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly overall correlated with `volume_products` and 5 other fields	High correlation
`recency_days` is highly overall correlated with `purchases` and 2 other fields	High correlation
`volume_products` is highly overall correlated with `gross_revenue` and 5 other fields	High correlation
`assort_products` is highly overall correlated with `gross_revenue` and 4 other fields	High correlation
`purchases` is highly overall correlated with `gross_revenue` and 6 other fields	High correlation
`avg_period_purchases` is highly overall correlated with `gross_revenue` and 4 other fields	High correlation
`frequency_purchase` is highly overall correlated with `recency_days` and 2 other fields	High correlation
`volume_basket_size` is highly overall correlated with `gross_revenue` and 4 other fields	High correlation
`assort_basket_size` is highly overall correlated with `assort_products` and 2 other fields	High correlation
`avg_ticket` is highly overall correlated with `gross_revenue` and 4 other fields	High correlation
`returns_purchases` is highly overall correlated with `purchases` and 1 other fields	High correlation
`returns_products` is highly overall correlated with `purchases` and 1 other fields	High correlation
`gross_revenue` is highly skewed (γ1 = 21.65488511)	Skewed
`volume_products` is highly skewed (γ1 = 23.05712012)	Skewed
`volume_basket_size` is highly skewed (γ1 = 48.53495052)	Skewed
`avg_ticket` is highly skewed (γ1 = 27.82299041)	Skewed
`returns_products` is highly skewed (γ1 = 51.52432388)	Skewed
`customer_id` has unique values	Unique
`returns_purchases` has 4190 (73.6%) zeros	Zeros
`returns_products` has 4190 (73.6%) zeros	Zeros

Reproduction

Analysis started	2023-05-11 21:54:59.518637
Analysis finished	2023-05-11 21:56:26.911617
Duration	1 minute and 27.39 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	5695
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16600.708

Minimum	12346
Maximum	22709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	12346
5-th percentile	12699.1
Q1	14288.5
median	16229
Q3	18210.5
95-th percentile	21731.1
Maximum	22709
Range	10363
Interquartile range (IQR)	3922

Descriptive statistics

Standard deviation	2808.2237
Coefficient of variation (CV)	0.16916289
Kurtosis	-0.82112934
Mean	16600.708
Median Absolute Deviation (MAD)	1962
Skewness	0.4411659
Sum	94541034
Variance	7886120.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
21110	1	< 0.1%
13745	1	< 0.1%
15584	1	< 0.1%
21089	1	< 0.1%
21088	1	< 0.1%
21087	1	< 0.1%
21086	1	< 0.1%
15578	1	< 0.1%
12424	1	< 0.1%
Other values (5685)	5685	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
22709	1	< 0.1%
22708	1	< 0.1%
22707	1	< 0.1%
22706	1	< 0.1%
22705	1	< 0.1%
22704	1	< 0.1%
22700	1	< 0.1%
22699	1	< 0.1%
22696	1	< 0.1%
22695	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5449
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1802.4803

Minimum	0.42
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0.42
5-th percentile	13.171
Q1	236.135
median	612.78
Q3	1568.67
95-th percentile	5323.416
Maximum	279138.02
Range	279137.6
Interquartile range (IQR)	1332.535

Descriptive statistics

Standard deviation	7882.9985
Coefficient of variation (CV)	4.3734172
Kurtosis	610.54599
Mean	1802.4803
Median Absolute Deviation (MAD)	478.68
Skewness	21.654885
Sum	10265126
Variance	62141665
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
4.95	8	0.1%
2.95	8	0.1%
1.25	8	0.1%
1.65	7	0.1%
3.75	7	0.1%
12.75	7	0.1%
4.25	6	0.1%
7.5	6	0.1%
5.95	6	0.1%
Other values (5439)	5623	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%
1.69	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%

recency_days
Real number (ℝ)

Distinct	304
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.90694

Minimum	0
Maximum	373
Zeros	38
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	22.5
median	71
Q3	200
95-th percentile	338
Maximum	373
Range	373
Interquartile range (IQR)	177.5

Descriptive statistics

Standard deviation	111.6299
Coefficient of variation (CV)	0.95486123
Kurtosis	-0.64357629
Mean	116.90694
Median Absolute Deviation (MAD)	61
Skewness	0.81400758
Sum	665785
Variance	12461.235
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	91	1.6%
10	86	1.5%
8	82	1.4%
17	79	1.4%
9	79	1.4%
7	78	1.4%
15	67	1.2%
Other values (294)	4820	84.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38	0.7%
1	110	1.9%
2	91	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	22	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

volume_products
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1843
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.61387

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	106
median	317
Q3	805.5
95-th percentile	2943.3
Maximum	196844
Range	196843
Interquartile range (IQR)	699.5

Descriptive statistics

Standard deviation	4428.7397
Coefficient of variation (CV)	4.5255231
Kurtosis	785.48718
Mean	978.61387
Median Absolute Deviation (MAD)	253
Skewness	23.05712
Sum	5573206
Variance	19613735
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	72	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	25	0.4%
88	22	0.4%
72	21	0.4%
7	20	0.4%
Other values (1833)	5257	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	114	2.0%
2	72	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
7	20	0.4%
8	18	0.3%
9	7	0.1%
10	17	0.3%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%

assort_products
Real number (ℝ)

Distinct	436
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.654785

Minimum	1
Maximum	1785
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	13
median	36
Q3	84.5
95-th percentile	241.3
Maximum	1785
Range	1784
Interquartile range (IQR)	71.5

Descriptive statistics

Standard deviation	101.71166
Coefficient of variation (CV)	1.4602251
Kurtosis	43.866694
Mean	69.654785
Median Absolute Deviation (MAD)	28
Skewness	4.7027614
Sum	396684
Variance	10345.262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	279	4.9%
2	148	2.6%
3	114	2.0%
10	101	1.8%
5	99	1.7%
9	96	1.7%
11	92	1.6%
6	92	1.6%
8	92	1.6%
7	91	1.6%
Other values (426)	4491	78.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	279	4.9%
2	148	2.6%
3	114	2.0%
4	89	1.6%
5	99	1.7%
6	92	1.6%
7	91	1.6%
8	92	1.6%
9	96	1.7%
10	101	1.8%

Value	Count	Frequency (%)
1785	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
1108	1	< 0.1%
884	1	< 0.1%
816	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%

purchases
Real number (ℝ)

Distinct	57
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4691835

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	205
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.8029408
Coefficient of variation (CV)	1.9609631
Kurtosis	301.26194
Mean	3.4691835
Median Absolute Deviation (MAD)	0
Skewness	13.171132
Sum	19757
Variance	46.280004
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2871	50.4%
2	827	14.5%
3	501	8.8%
4	395	6.9%
5	236	4.1%
6	173	3.0%
7	139	2.4%
8	98	1.7%
9	69	1.2%
11	54	0.9%
Other values (47)	332	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2871	50.4%
2	827	14.5%
3	501	8.8%
4	395	6.9%
5	236	4.1%
6	173	3.0%
7	139	2.4%
8	98	1.7%
9	69	1.2%
10	54	0.9%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%

avg_period_purchases
Real number (ℝ)

Distinct	1155
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	243.66978

Minimum	1
Maximum	400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	1
5-th percentile	19.829167
Q1	60.633333
median	400
Q3	400
95-th percentile	400
Maximum	400
Range	399
Interquartile range (IQR)	339.36667

Descriptive statistics

Standard deviation	167.11895
Coefficient of variation (CV)	0.68584191
Kurtosis	-1.8360794
Mean	243.66978
Median Absolute Deviation (MAD)	0
Skewness	-0.21922616
Sum	1387699.4
Variance	27928.742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	2923	51.3%
70	21	0.4%
46	18	0.3%
55	17	0.3%
49	16	0.3%
31	16	0.3%
91	16	0.3%
21	15	0.3%
35	15	0.3%
42	15	0.3%
Other values (1145)	2623	46.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.2%
2	4	0.1%
2.88372093	1	< 0.1%
3	6	0.1%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	4	0.1%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
400	2923	51.3%
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	< 0.1%
356	1	< 0.1%
355	2	< 0.1%
352	1	< 0.1%
351	2	< 0.1%

frequency_purchase
Real number (ℝ)

Distinct	1222
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.023062775

Minimum	0.0026737968
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0.0026737968
5-th percentile	0.0029673591
Q1	0.0054495913
median	0.012012012
Q3	0.023798006
95-th percentile	0.068799621
Maximum	1
Range	0.9973262
Interquartile range (IQR)	0.018348415

Descriptive statistics

Standard deviation	0.048276932
Coefficient of variation (CV)	2.0932838
Kurtosis	173.37146
Mean	0.023062775
Median Absolute Deviation (MAD)	0.0075001831
Skewness	10.798272
Sum	131.3425
Variance	0.0023306622
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01851851852	37	0.6%
0.005405405405	32	0.6%
0.01639344262	31	0.5%
0.004672897196	30	0.5%
0.002824858757	30	0.5%
0.01538461538	29	0.5%
0.05263157895	29	0.5%
0.01923076923	28	0.5%
0.025	27	0.5%
0.04545454545	26	0.5%
Other values (1212)	5396	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.002673796791	22	0.4%
0.002680965147	21	0.4%
0.002688172043	17	0.3%
0.002702702703	3	0.1%
0.0027100271	13	0.2%
0.002717391304	16	0.3%
0.00272479564	14	0.2%
0.002732240437	19	0.3%
0.002739726027	11	0.2%
0.002754820937	7	0.1%

Value	Count	Frequency (%)
1	5	0.1%
0.550802139	1	< 0.1%
0.5294117647	1	< 0.1%
0.5	11	0.2%
0.4	1	< 0.1%
0.3333333333	6	0.1%
0.3315508021	1	< 0.1%
0.3157894737	1	< 0.1%
0.2727272727	2	< 0.1%
0.2621621622	1	< 0.1%

volume_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2366
Distinct (%)	41.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	268.28332

Minimum	1
Maximum	74215
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	75
median	152
Q3	290.70833
95-th percentile	734.3
Maximum	74215
Range	74214
Interquartile range (IQR)	215.70833

Descriptive statistics

Standard deviation	1199.2079
Coefficient of variation (CV)	4.4699309
Kurtosis	2768.2881
Mean	268.28332
Median Absolute Deviation (MAD)	97
Skewness	48.534951
Sum	1527873.5
Variance	1438099.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	115	2.0%
2	71	1.2%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	26	0.5%
72	22	0.4%
100	22	0.4%
88	21	0.4%
Other values (2356)	5254	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	115	2.0%
2	71	1.2%
3	51	0.9%
3.333333333	1	< 0.1%
4	49	0.9%
5	35	0.6%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	29	0.5%
6.142857143	1	< 0.1%

Value	Count	Frequency (%)
74215	1	< 0.1%
40498.5	1	< 0.1%
14149	1	< 0.1%
13956	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
5963	1	< 0.1%
5196	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%

assort_basket_size
Real number (ℝ)

Distinct	1178
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.250387

Minimum	0.2
Maximum	1108
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0.2
5-th percentile	1
Q1	7.2052632
median	15
Q3	31
95-th percentile	173
Maximum	1108
Range	1107.8
Interquartile range (IQR)	23.794737

Descriptive statistics

Standard deviation	76.862176
Coefficient of variation (CV)	2.0633927
Kurtosis	32.882585
Mean	37.250387
Median Absolute Deviation (MAD)	10
Skewness	5.0736237
Sum	212140.96
Variance	5907.7941
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	278	4.9%
2	160	2.8%
3	115	2.0%
9	106	1.9%
10	105	1.8%
7	103	1.8%
8	102	1.8%
5	102	1.8%
6	101	1.8%
13	99	1.7%
Other values (1168)	4424	77.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.1%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.2%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
1108	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
703	1	< 0.1%
686	1	< 0.1%
674	1	< 0.1%
673	1	< 0.1%
660	1	< 0.1%
649	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5454
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	581.82347

Minimum	0.42
Maximum	84236.25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0.42
5-th percentile	12.835
Q1	158.9
median	296.915
Q3	486.1065
95-th percentile	1840.001
Maximum	84236.25
Range	84235.83
Interquartile range (IQR)	327.2065

Descriptive statistics

Standard deviation	2040.7306
Coefficient of variation (CV)	3.5074738
Kurtosis	987.91504
Mean	581.82347
Median Absolute Deviation (MAD)	151.915
Skewness	27.82299
Sum	3313484.7
Variance	4164581.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
4.95	8	0.1%
2.95	8	0.1%
1.25	8	0.1%
3.75	7	0.1%
1.65	7	0.1%
12.75	7	0.1%
7.5	6	0.1%
4.25	6	0.1%
5.95	6	0.1%
Other values (5444)	5623	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%
1.69	1	< 0.1%

Value	Count	Frequency (%)
84236.25	1	< 0.1%
77183.6	1	< 0.1%
52940.94	1	< 0.1%
50653.91	1	< 0.1%
21389.6	1	< 0.1%
18745.86	1	< 0.1%
14844.76667	1	< 0.1%
14838.86	1	< 0.1%
13305.5	1	< 0.1%
12681.58	1	< 0.1%

returns_purchases
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.58841089

Minimum	0
Maximum	45
Zeros	4190
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.7505699
Coefficient of variation (CV)	2.9750808
Kurtosis	190.41518
Mean	0.58841089
Median Absolute Deviation (MAD)	0
Skewness	10.266086
Sum	3351
Variance	3.0644951
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	4190	73.6%
1	850	14.9%
2	289	5.1%
3	140	2.5%
4	92	1.6%
5	37	0.6%
6	32	0.6%
7	21	0.4%
9	8	0.1%
11	5	0.1%
Other values (13)	31	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	73.6%
1	850	14.9%
2	289	5.1%
3	140	2.5%
4	92	1.6%
5	37	0.6%
6	32	0.6%
7	21	0.4%
8	5	0.1%
9	8	0.1%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	5	0.1%

returns_products
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	216
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.084284

Minimum	0
Maximum	80995
Zeros	4190
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	89.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	39
Maximum	80995
Range	80995
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1474.76
Coefficient of variation (CV)	31.321704
Kurtosis	2718.148
Mean	47.084284
Median Absolute Deviation (MAD)	0
Skewness	51.524324
Sum	268145
Variance	2174917.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4190	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
6	78	1.4%
5	61	1.1%
12	52	0.9%
7	44	0.8%
8	43	0.8%
Other values (206)	714	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
5	61	1.1%
6	78	1.4%
7	44	0.8%
8	43	0.8%
9	41	0.7%

Value	Count	Frequency (%)
80995	1	< 0.1%
74215	1	< 0.1%
9360	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3331	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	recency_days	volume_products	assort_products	purchases	avg_period_purchases	frequency_purchase	volume_basket_size	assort_basket_size	avg_ticket	returns_purchases	returns_products
customer_id	1.000	-0.181	0.245	-0.291	-0.017	-0.383	0.380	-0.215	-0.147	0.134	-0.040	-0.274	-0.277
gross_revenue	-0.181	1.000	-0.426	0.929	0.794	0.644	-0.570	0.403	0.722	0.370	0.765	0.440	0.435
recency_days	0.245	-0.426	1.000	-0.496	-0.326	-0.596	0.541	-0.872	-0.198	0.050	-0.085	-0.330	-0.321
volume_products	-0.291	0.929	-0.496	1.000	0.734	0.694	-0.624	0.472	0.790	0.298	0.651	0.459	0.458
assort_products	-0.017	0.794	-0.326	0.734	1.000	0.450	-0.383	0.291	0.618	0.733	0.639	0.280	0.270
purchases	-0.383	0.644	-0.596	0.694	0.450	1.000	-0.923	0.545	0.157	-0.180	0.077	0.551	0.539
avg_period_purchases	0.380	-0.570	0.541	-0.624	-0.383	-0.923	1.000	-0.565	-0.142	0.180	-0.062	-0.487	-0.478
frequency_purchase	-0.215	0.403	-0.872	0.472	0.291	0.545	-0.565	1.000	0.194	-0.072	0.080	0.320	0.312
volume_basket_size	-0.147	0.722	-0.198	0.790	0.618	0.157	-0.142	0.194	1.000	0.570	0.854	0.173	0.183
assort_basket_size	0.134	0.370	0.050	0.298	0.733	-0.180	0.180	-0.072	0.570	1.000	0.640	-0.102	-0.102
avg_ticket	-0.040	0.765	-0.085	0.651	0.639	0.077	-0.062	0.080	0.854	0.640	1.000	0.152	0.157
returns_purchases	-0.274	0.440	-0.330	0.459	0.280	0.551	-0.487	0.320	0.173	-0.102	0.152	1.000	0.987
returns_products	-0.277	0.435	-0.321	0.458	0.270	0.539	-0.478	0.312	0.183	-0.102	0.157	0.987	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	volume_products	assort_products	purchases	avg_period_purchases	frequency_purchase	volume_basket_size	assort_basket_size	avg_ticket	returns_purchases	returns_products
0	17850	5391.210	372.000	1733.000	21.000	34.000	1.000	0.091	50.971	0.618	158.565	1.000	40.000
1	13047	3232.590	56.000	1390.000	105.000	9.000	52.833	0.024	154.444	11.667	359.177	7.000	35.000
2	12583	6705.380	2.000	5028.000	114.000	15.000	26.500	0.040	335.200	7.600	447.025	2.000	50.000
3	13748	948.250	95.000	439.000	24.000	5.000	92.667	0.013	87.800	4.800	189.650	0.000	0.000
4	15100	876.000	333.000	80.000	1.000	3.000	20.000	0.008	26.667	0.333	292.000	3.000	22.000
5	15291	4623.300	25.000	2102.000	61.000	14.000	26.769	0.037	150.143	4.357	330.236	5.000	29.000
6	14688	5630.870	7.000	3621.000	148.000	21.000	19.263	0.056	172.429	7.048	268.137	6.000	399.000
7	17809	5411.910	16.000	2057.000	46.000	12.000	39.667	0.032	171.417	3.833	450.993	2.000	41.000
8	15311	60767.900	0.000	38194.000	567.000	91.000	4.191	0.243	419.714	6.231	667.779	27.000	474.000
9	16098	2005.630	87.000	613.000	34.000	7.000	47.667	0.019	87.571	4.857	286.519	0.000	0.000

	customer_id	gross_revenue	recency_days	volume_products	assort_products	purchases	avg_period_purchases	frequency_purchase	volume_basket_size	assort_basket_size	avg_ticket
5752	22700	4839.420	1.000	1074.000	55.000	1.000	400.000	0.500	1074.000	55.000	4839.420
5753	13298	360.000	1.000	96.000	2.000	1.000	400.000	0.500	96.000	2.000	360.000
5754	14569	227.390	1.000	79.000	10.000	1.000	400.000	0.500	79.000	10.000	227.390
5755	22704	17.900	1.000	14.000	7.000	1.000	400.000	0.500	14.000	7.000	17.900
5756	22705	3.350	1.000	2.000	2.000	1.000	400.000	0.500	2.000	2.000	3.350
5757	22706	5699.000	1.000	1747.000	634.000	1.000	400.000	0.500	1747.000	634.000	5699.000
5758	22707	6756.060	0.000	2010.000	730.000	1.000	400.000	1.000	2010.000	730.000	6756.060
5759	22708	3217.200	0.000	654.000	56.000	1.000	400.000	1.000	654.000	56.000	3217.200
5760	22709	3950.720	0.000	731.000	217.000	1.000	400.000	1.000	731.000	217.000	3950.720
5761	12713	794.550	0.000	505.000	37.000	1.000	400.000	1.000	505.000	37.000	794.550

Overview

Variables

Interactions

Correlations

Missing values

Sample